/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 50723
 Source Host           : localhost:3306
 Source Schema         : pricesystem

 Target Server Type    : MySQL
 Target Server Version : 50723
 File Encoding         : 65001

 Date: 08/11/2019 23:28:22
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for db_category
-- ----------------------------
DROP TABLE IF EXISTS `db_category`;
CREATE TABLE `db_category` (
  `category_id` int(11) NOT NULL AUTO_INCREMENT,
  `category_name` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of db_category
-- ----------------------------
BEGIN;
INSERT INTO `db_category` VALUES (1, '暖气片234', '300*1200', 1, '2019-11-12 12:50:53', '2019-11-18 12:50:56');
INSERT INTO `db_category` VALUES (2, '暖气片', '', 0, '2019-11-03 22:34:43', '2019-11-03 22:34:43');
COMMIT;

-- ----------------------------
-- Table structure for db_product
-- ----------------------------
DROP TABLE IF EXISTS `db_product`;
CREATE TABLE `db_product` (
  `product_id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) DEFAULT NULL COMMENT '产品类别',
  `product_name` varchar(255) NOT NULL COMMENT '产品名称',
  `spec` varchar(255) NOT NULL COMMENT '规格',
  `heat_value` int(11) DEFAULT NULL COMMENT '热值',
  `unit` varchar(255) NOT NULL COMMENT '单位',
  `price` int(11) NOT NULL COMMENT '价格',
  `brand` varchar(255) DEFAULT NULL COMMENT '品牌',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `project` int(11) NOT NULL COMMENT '项目类别',
  `status` int(11) NOT NULL COMMENT '状态',
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of db_product
-- ----------------------------
BEGIN;
INSERT INTO `db_product` VALUES (13, 2, '钢制板式暖气片', 'PKKP22-300*1200', 1402, '组', 649, '德国普特斯', '原装进口', 1, 0, '2019-11-05 15:43:29', '2019-11-05 15:43:29');
INSERT INTO `db_product` VALUES (14, 2, '钢制板式暖气片', 'PKKP22-300*1400', 1635, '组', 739, '德国普特斯', '原装进口', 1, 0, '2019-11-05 15:44:07', '2019-11-05 15:44:07');
INSERT INTO `db_product` VALUES (15, 2, '钢制板式暖气片', 'PKKP22-300*1600', 1869, '组', 811, '德国普特斯', '原装进口', 1, 0, '2019-11-05 15:44:42', '2019-11-05 15:44:42');
INSERT INTO `db_product` VALUES (16, 2, '钢制板式暖气片', 'PKKP22-300*1800', 2102, '组', 879, '德国普特斯', '原装进口', 1, 0, '2019-11-05 15:44:54', '2019-11-05 15:44:54');
INSERT INTO `db_product` VALUES (17, 2, '钢制板式暖气片', 'PKKP22-300*2000', 2336, '组', 966, '德国普特斯', '原装进口', 1, 0, '2019-11-05 15:45:14', '2019-11-05 15:45:14');
INSERT INTO `db_product` VALUES (18, 2, '钢制板式暖气片', 'PKKP22-300*2200', 2570, '组', 1044, '德国普特斯', '原装进口', 1, 0, '2019-11-05 15:45:26', '2019-11-05 15:45:26');
INSERT INTO `db_product` VALUES (19, 2, '钢制板式暖气片', 'PKKP22-300*2400', 2803, '组', 1141, '德国普特斯', '原装进口', 1, 0, '2019-11-05 15:45:44', '2019-11-05 15:45:44');
INSERT INTO `db_product` VALUES (20, 2, '钢制板式暖气片', 'PKKP22-300*2600', 3037, '组', 1239, '德国普特斯', '原装进口', 1, 0, '2019-11-05 15:45:55', '2019-11-05 15:45:55');
INSERT INTO `db_product` VALUES (21, 2, '钢制板式暖气片', 'PKKP22-600*800', 1560, '组', 670, '德国普特斯', '原装进口', 1, 0, '2019-11-05 15:46:17', '2019-11-05 15:46:17');
INSERT INTO `db_product` VALUES (22, 2, '钢制板式暖气片', 'PKKP22-600*1000', 1950, '组', 753, '德国普特斯', '原装进口', 1, 0, '2019-11-05 15:46:34', '2019-11-05 15:46:34');
INSERT INTO `db_product` VALUES (23, 2, '钢制板式暖气片', 'PKKP22-600*1200', 2340, '组', 890, '德国普特斯', '原装进口', 1, 0, '2019-11-05 15:46:42', '2019-11-05 15:46:42');
INSERT INTO `db_product` VALUES (24, 2, '钢制板式暖气片', 'PKKP22-600*1400', 2730, '组', 999, '德国普特斯', '原装进口', 1, 0, '2019-11-05 15:46:52', '2019-11-05 15:46:52');
INSERT INTO `db_product` VALUES (25, 2, '钢制板式暖气片', 'PKKP22-600*1600', 3120, '组', 1110, '德国普特斯', '原装进口', 1, 0, '2019-11-05 15:47:06', '2019-11-05 15:47:06');
INSERT INTO `db_product` VALUES (26, 2, '钢制板式暖气片', 'PKKP22-600*1800', 3510, '组', 1219, '德国普特斯', '原装进口', 1, 0, '2019-11-05 15:47:23', '2019-11-05 15:47:23');
INSERT INTO `db_product` VALUES (27, 2, '钢制板式暖气片', 'PKKP22-600*2000', 3900, '组', 1329, '德国普特斯', '原装进口', 1, 0, '2019-11-05 15:47:35', '2019-11-05 15:47:35');
INSERT INTO `db_product` VALUES (28, 2, '钢制板式暖气片', 'PKKP22-600*2200', 4298, '组', 1437, '德国普特斯', '原装进口', 1, 0, '2019-11-05 15:47:43', '2019-11-05 15:47:43');
INSERT INTO `db_product` VALUES (29, 2, '钢制板式暖气片', 'PKKP22-400*1400', 1980, '组', 913, '德国普特斯', '原装进口', 1, 0, '2019-11-05 15:47:57', '2019-11-05 15:47:57');
INSERT INTO `db_product` VALUES (30, 2, '钢制板式暖气片', 'PKKP22-400*1600', 2262, '组', 1021, '德国普特斯', '原装进口', 1, 0, '2019-11-05 15:48:09', '2019-11-05 15:48:09');
INSERT INTO `db_product` VALUES (31, 2, '钢制板式暖气片', 'PKKP22-400*1800', 2545, '组', 1104, '德国普特斯', '原装进口', 1, 0, '2019-11-05 15:48:25', '2019-11-05 15:48:25');
INSERT INTO `db_product` VALUES (32, 2, '钢制板式暖气片', 'PKKP22-400*2000', 2828, '组', 1223, '德国普特斯', '原装进口', 1, 0, '2019-11-05 15:48:37', '2019-11-05 15:48:37');
INSERT INTO `db_product` VALUES (33, 2, '钢制板式暖气片', 'PKKP22-900*600', 1567, '组', 774, '德国普特斯', '原装进口', 1, 0, '2019-11-05 15:49:17', '2019-11-05 15:49:17');
INSERT INTO `db_product` VALUES (34, 2, '钢制板式暖气片', 'PKKP22-900*800', 2089, '组', 929, '德国普特斯', '原装进口', 1, 0, '2019-11-05 15:49:28', '2019-11-05 15:49:28');
INSERT INTO `db_product` VALUES (35, 2, '钢制板式暖气片', 'PKKP22-900*1000', 2512, '组', 1119, '德国普特斯', '原装进口', 1, 0, '2019-11-05 15:49:54', '2019-11-05 15:49:54');
INSERT INTO `db_product` VALUES (36, 2, '钢制板式暖气片', 'PKKP22-900*1200', 3014, '组', 1281, '德国普特斯', '原装进口', 1, 0, '2019-11-05 15:50:05', '2019-11-05 15:50:05');
INSERT INTO `db_product` VALUES (37, 2, '钢制板式暖气片', 'PKKPKP33-900*600', 2251, '组', 1061, '德国普特斯', '原装进口', 1, 0, '2019-11-05 15:53:32', '2019-11-05 15:53:32');
INSERT INTO `db_product` VALUES (38, 2, '钢制板式暖气片', 'PKKPKP33-900*800', 3002, '组', 1284, '德国普特斯', '原装进口', 1, 0, '2019-11-05 15:53:46', '2019-11-05 15:53:46');
INSERT INTO `db_product` VALUES (39, 2, '钢制板式暖气片', 'PKKPKP33-900*1000', 3752, '组', 1516, '德国普特斯', '原装进口', 1, 0, '2019-11-05 15:53:56', '2019-11-05 15:53:56');
INSERT INTO `db_product` VALUES (40, 2, '钢制柱式暖气片', '1800*4柱', 1176, '组', 734, '海森博', '营口', 1, 0, '2019-11-05 15:54:43', '2019-11-05 15:54:43');
INSERT INTO `db_product` VALUES (41, 2, '钢制柱式暖气片', '1800*5柱', 1485, '组', 909, '海森博', '营口', 1, 0, '2019-11-05 15:55:03', '2019-11-05 15:55:03');
INSERT INTO `db_product` VALUES (42, 2, '钢制柱式暖气片', '1800*6柱', 1764, '组', 1055, '海森博', '营口', 1, 0, '2019-11-05 15:56:27', '2019-11-05 15:56:27');
INSERT INTO `db_product` VALUES (43, 2, '钢制柱式暖气片', '1800*7柱', 2058, '组', 1219, '海森博', '营口', 1, 0, '2019-11-05 15:56:41', '2019-11-05 15:56:41');
INSERT INTO `db_product` VALUES (44, 2, '钢制柱式暖气片', '1800*8柱', 2352, '组', 1382, '海森博', '营口', 1, 0, '2019-11-05 15:56:53', '2019-11-05 15:56:53');
INSERT INTO `db_product` VALUES (45, 2, '钢制柱式暖气片', '1800*9柱', 2646, '组', 1546, '海森博', '营口', 1, 0, '2019-11-05 15:57:04', '2019-11-05 15:57:04');
INSERT INTO `db_product` VALUES (46, 2, '钢制柱式暖气片', '1800*10柱', 2940, '组', 1710, '海森博', '营口', 1, 0, '2019-11-05 15:57:16', '2019-11-05 15:57:16');
INSERT INTO `db_product` VALUES (47, 2, '钢制柱式暖气片', '1800*11柱', 3234, '组', 1881, '海森博', '营口', 1, 0, '2019-11-05 15:57:28', '2019-11-05 15:57:28');
INSERT INTO `db_product` VALUES (48, 2, '卫浴暖气片', '500*800', 620, '组', 424, '德国普特斯', '江西', 1, 0, '2019-11-05 16:05:14', '2019-11-05 16:05:14');
INSERT INTO `db_product` VALUES (49, 2, '卫浴暖气片', '500*1000', 710, '组', 466, '德国普特斯', '江西', 1, 0, '2019-11-05 16:05:25', '2019-11-05 16:05:25');
INSERT INTO `db_product` VALUES (50, 2, '卫浴暖气片', '500*1200', 745, '组', 521, '德国普特斯', '江西', 1, 0, '2019-11-05 16:05:36', '2019-11-05 16:05:36');
INSERT INTO `db_product` VALUES (51, 1, '新欧洲之星24kw两用炉', 'WBN6000 24C', 24000, '台', 7200, '德国博世', '原装进口', 1, 0, '2019-11-05 16:10:14', '2019-11-05 16:10:14');
INSERT INTO `db_product` VALUES (52, 1, '新欧洲之星28kw两用炉', 'WBN6000 28C', 28000, '台', 9600, '德国博世', '原装进口', 1, 0, '2019-11-05 16:11:07', '2019-11-05 16:11:07');
INSERT INTO `db_product` VALUES (53, 1, '新欧洲之星35kw两用炉', 'WBN6000 35C', 35000, '台', 11500, '德国博世', '原装进口', 1, 0, '2019-11-05 16:11:55', '2019-11-05 16:11:55');
INSERT INTO `db_product` VALUES (54, 1, '欧洲贵族25kw两用炉', 'ZWB25-3A23', 25000, '台', 14800, '德国博世', '上海', 1, 0, '2019-11-05 16:14:07', '2019-11-05 16:14:07');
INSERT INTO `db_product` VALUES (55, 1, '欧洲贵族30kw两用炉', 'ZWB30-3A23', 30000, '台', 16000, '德国博世', '上海', 1, 0, '2019-11-05 16:14:35', '2019-11-05 16:14:35');
INSERT INTO `db_product` VALUES (56, 1, '欧洲贵族35kw两用炉', 'ZWB35-3A23', 35000, '台', 17800, '德国博世', '上海', 1, 0, '2019-11-05 16:14:49', '2019-11-05 16:14:49');
INSERT INTO `db_product` VALUES (57, 1, '欧洲贵族42kw两用炉', 'ZWB42-3A23', 42000, '台', 20400, '德国博世', '上海', 1, 0, '2019-11-05 16:15:29', '2019-11-05 16:15:29');
INSERT INTO `db_product` VALUES (58, 1, '暖气片', '3320*1300', NULL, '组', 1000, '德国普特斯', NULL, 1, 0, '2019-11-05 21:19:24', '2019-11-05 21:19:24');
COMMIT;

-- ----------------------------
-- Table structure for db_user
-- ----------------------------
DROP TABLE IF EXISTS `db_user`;
CREATE TABLE `db_user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of db_user
-- ----------------------------
BEGIN;
INSERT INTO `db_user` VALUES (1, 'admin', '5c4f188aabf05ead75d73079c1b83fa4', '2019-11-14 23:12:07', '2019-11-08 23:12:10');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
